package com.fowo.api.model.logistics.reconciliation;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.common.validator.EnumsString;
import javax.validation.constraints.*;
import lombok.Getter;
import lombok.Setter;

/** 物流对账 导入导出辅助模型 */
@Getter
@Setter
public class LogisticsReconciliationExcelPo {

  @Size(max = 50, message = "销售出库单长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "销售出库单")
  private String salesoutboundorder;

  @Size(max = 100, message = "运单号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "运单号")
  private String waybillnumber;

  @Size(max = 100, message = "跟踪单号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "跟踪单号")
  private String trackingnumber;

  @Size(max = 50, message = "系统单号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "系统单号")
  private String sysnumber;

  @Size(max = 50, message = "店铺长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "店铺")
  private String shopIdShopName;

  @ExcelIgnore
  @ExcelProperty(value = "店铺")
  private Long shopId;

  @Size(max = 50, message = "平台单号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "平台单号")
  private String platformnumber;

  @EnumsString(
    value = { "待确认", "已确认", "已删除" },
    message = "状态的可用值为 “待确认”, “已确认”, “已删除” 其中之一"
  )
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "状态")
  private String state;

  @DateTimeFormat("yyyy年MM月dd日HH:mm:ss")
  @ExcelProperty(value = "发货日期")
  private java.util.Date sendgoodsdate;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "物流商")
  private String logisticsproviderName;

  @ExcelIgnore
  @ExcelProperty(value = "物流商")
  private Long logisticsprovider;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "物流渠道")
  private String logisticschannelName;

  @ExcelIgnore
  @ExcelProperty(value = "物流渠道")
  private Long logisticschannel;

  @ExcelProperty(value = "预估费用")
  private java.math.BigDecimal estimatedfee;

  @ExcelProperty(value = "预估费用（对账）")
  private java.math.BigDecimal chargedfee;

  @ExcelProperty(value = "物流运费")
  private java.math.BigDecimal logisticsfee;

  @ExcelProperty(value = "物流运费(对账)")
  private java.math.BigDecimal logisticsfeereconc;

  @ExcelProperty(value = "运费差异")
  private java.math.BigDecimal logisticsfeediff;

  @ExcelProperty(value = "称重重量")
  private java.math.BigDecimal chargedweight;

  @ExcelProperty(value = "计费重量")
  private java.math.BigDecimal chargingweight;

  @ExcelProperty(value = "重量差异")
  private java.math.BigDecimal weightdiff;

  @EnumsString(
    value = { "是", "否" },
    message = "是否获取运费的可用值为 “是”, “否” 其中之一"
  )
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "是否获取运费")
  private String isobtainshippingcosts;

  @Size(max = 50, message = "备注长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "备注")
  private String remarks;
}
